package net.adetech.cjg.innerservice.mapper;


import net.adetech.cjg.innerservice.entity.Qzb;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface QzbDao {
    @Select("select * from cjg_qzb where yhzh = #{yhzh}")
    Qzb getQmbByYhzh(String yhzh);

    @Update("update cjg_qzb set qz_img = #{qzImg} where yhzh = #{yhzh}")
    void updateQz(Qzb qzb);

    @Insert("insert into cjg_qzb (id,yhzh,yhm,qz_img) values (HIBERNATE_SEQUENCE.nextval,#{yhzh},#{yhm},#{qzImg})")
    void newQz(Qzb qzb);

}
